﻿using System;
using System.Collections.Generic;
using System.Text;

namespace AppGauge.Data
{
    class AppTable
    {

        public string CreateMetaTable()
        {
return @"
    CREATE TABLE [dbo].[tblMeta](
	[slId] [int] IDENTITY(1,1) NOT NULL primary key,
	[uid] [varbinary](50) NOT NULL,
	[upass] [varchar](50) NOT NULL,
	[uemail] [varchar](50) NOT NULL,
	[authorName] [varchar](50) NOT NULL,
	[authorEmail] [varchar](50) NOT NULL,
	[appStatus] [char](1) NOT NULL DEFAULT ('a'),
	[appUrl] [varchar](50) NULL DEFAULT ('#'),
	[appName] [varchar](50) NULL,
	[appDescription] [varchar](50) NULL,
	[appKeyword] [varchar](50) NULL,
	[appCopyright] [varchar](500) NULL DEFAULT ('Copyright &copy; 2013. All Rights Reserved.'),
	[contactName] [varchar](50) NULL,
	[contactAddresLine1] [varchar](50) NULL,
	[contactAddressLine2] [varchar](50) NULL,
	[contactAddressLine3] [varchar](50) NULL,
	[contactPhone1] [varchar](50) NULL,
	[contactPhone2] [varchar](50) NULL,
	[contactEmail] [varchar](50) NULL,
	[contactUrl] [varchar](50) NULL DEFAULT ('#'),
	[developer] [varchar](50) NULL)
    ";
        }
    }
}
